<?php
include 'checkSession.php';
$pageName = "SignFace";
if(isset($_REQUEST['action'])) {
	if($_REQUEST['action'] == 'edit' || $_REQUEST['action'] == 'view' || $_REQUEST['action'] == 'chPass') {
		$editQry = mysql_fetch_array(mysql_query("SELECT *
													   FROM `Sign_Faces`
													   WHERE `sf_id` = '".$_REQUEST['id']."'"));
	    $editActivityQry = mysql_fetch_array(mysql_query("SELECT *
													   FROM `Sign_Activity`
													   WHERE `sa_sf_id` = '".$_REQUEST['id']."'"));
		
		$sf_id = $editQry['sf_id'];
	}
	
	if($_REQUEST['action'] == 'add') {
	$idQry = mysql_fetch_array(mysql_query("SELECT *
													   FROM `Sign_Faces`
													   ORDER BY `sf_id` DESC"));
	}
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
	<title>Sign Inventory</title>
	<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
	<script type="text/javascript">
function validationBuyerAdd() {
		var emailExp = /^[\w\-\.\+]+\@[a-zA-Z0-9\.\-]+\.[a-zA-z0-9]{2,4}$/;
		var regexp = /http:\/\/[A-Za-z0-9\.-]{3,}\.[A-Za-z]{3}/;
		var char=/^[0-9]+$/;
		var operatorFirstname = document.operatorForm.operatorFirstname.value;
		var operatorLastname = document.operatorForm.operatorLastname.value;
		var operatorPhone = document.operatorForm.operatorPhone.value;
		var operatorpassword = document.operatorForm.operatorpassword.value;
		
		if(operatorFirstname =="" || operatorFirstname == 0 || operatorFirstname.replace(/^\s+|\s+$/g,"").length == 0) {
			alert("First Name should not be empty or blank! Please enter First Name");
			document.operatorForm.operatorFirstname.focus();return false;
		}
		if(operatorLastname =="" || operatorLastname == 0 || operatorLastname.replace(/^\s+|\s+$/g,"").length == 0) {
			alert("Last Name should not be empty or blank! Please enter Last Name");
			document.sign_postsForm.sign_postsLastname.focus();return false;
		}
		if(sign_postsPhone =="" || sign_postsPhone == 0 || sign_postsPhone.replace(/^\s+|\s+$/g,"").length == 0) {
			alert("Phone Number should not be empty or blank! Please enter Phone Number");
			document.sign_postsForm.sign_postsPhone.focus();return false;
		}
		if (check_exit(sign_postsPhone)==false){
			alert("Phone Number already Exit.");
			document.sign_postsForm.sign_postsPhone.select();return false;
		}
		if(sign_postspassword =="" || sign_postspassword == 0 || sign_postspassword.replace(/^\s+|\s+$/g,"").length == 0) {
			alert("Password should not be empty or blank! Please enter Password");
			document.operatorForm.operatorpassword.focus();return false;
		}
			return true;
	}
	
	function validationBuyerEdit() {
		var regexp = /http:\/\/[A-Za-z0-9\.-]{3,}\.[A-Za-z]{3}/;
		var char=/^[0-9]+$/;
		var userName = document.operatorForm.userName.value;
		var userPhoneNumber = document.operatorForm.userPhoneNumber.value;
		
		if(userName =="" || userName == 0 || userName.replace(/^\s+|\s+$/g,"").length == 0) {
			alert("Name should not be empty or blank! Please enter Name");
			document.operatorForm.userName.focus();return false;
		}
		return true;
	}
	
	function validationChangePassword(){
			var regexp = /http:\/\/[A-Za-z0-9\.-]{3,}\.[A-Za-z]{3}/;
			var char=/^[0-9]+$/;
			var oldPassword = document.changePassword.oldPassword.value;
			var newPassword = document.changePassword.newPassword.value;
			var newCPassword = document.changePassword.newCPassword.value;
			
			if(oldPassword =="" || oldPassword == 0 || oldPassword.replace(/^\s+|\s+$/g,"").length == 0) {
				alert("Please enter old password");
				document.changePassword.oldPassword.focus();return false;
			}
			if(newPassword =="" || newPassword == 0 || newPassword.replace(/^\s+|\s+$/g,"").length == 0) {
				alert("Please enter new password");
				document.changePassword.newPassword.focus();return false;
			}
			if(newCPassword =="" || newCPassword == 0 || newCPassword.replace(/^\s+|\s+$/g,"").length == 0) {
				alert("Please enter confirm password");
				document.changePassword.newCPassword.focus();return false;
			}
			if(newCPassword != newPassword) {
				alert("Please doesnot match. Try again.");
				document.changePassword.newCPassword.focus();return false;
			}
			return true;
	}
	
		
		

</script>
<script type="text/javascript" src="datePicker/jsDatePick.min.1.3.js"></script>
<link rel="stylesheet" type="text/css" href="datePicker/jsDatePick_ltr.min.css" />

<script type="text/javascript">
	window.onload = function(){
		new JsDatePick({
			useMode:2,
			target:"sf_date_installed",
			dateFormat:"%m-%d-%Y"
			/*selectedDate:{				This is an example of what the full configuration offers.
				day:5,						For full documentation about these settings please see the full version of the code.
				month:9,
				year:2006
			},
			yearsRange:[1978,2020],
			limitToToday:false,
			cellColorScheme:"beige",
			dateFormat:"%m-%d-%Y",
			imgPath:"img/",
			weekStartDay:1*/
		});
		new JsDatePick({
			useMode:2,
			target:"sf_date_last_insp",
			dateFormat:"%m-%d-%Y"
			/*selectedDate:{				This is an example of what the full configuration offers.
				day:5,						For full documentation about these settings please see the full version of the code.
				month:9,
				year:2006
			},
			yearsRange:[1978,2020],
			limitToToday:false,
			cellColorScheme:"beige",
			dateFormat:"%m-%d-%Y",
			imgPath:"img/",
			weekStartDay:1*/
		});
		
		new JsDatePick({
			useMode:2,
			target:"sf_date_next_insp",
			dateFormat:"%m-%d-%Y"
			/*selectedDate:{				This is an example of what the full configuration offers.
				day:5,						For full documentation about these settings please see the full version of the code.
				month:9,
				year:2006
			},
			yearsRange:[1978,2020],
			limitToToday:false,
			cellColorScheme:"beige",
			dateFormat:"%m-%d-%Y",
			imgPath:"img/",
			weekStartDay:1*/
		});
		new JsDatePick({
			useMode:2,
			target:"sf_replace_date",
			dateFormat:"%m-%d-%Y"
			/*selectedDate:{				This is an example of what the full configuration offers.
				day:5,						For full documentation about these settings please see the full version of the code.
				month:9,
				year:2006
			},
			yearsRange:[1978,2020],
			limitToToday:false,
			cellColorScheme:"beige",
			dateFormat:"%m-%d-%Y",
			imgPath:"img/",
			weekStartDay:1*/
		});
	};
</script>
</head>
<body>
<!-- Header -->
<div id="header">
	<div class="shell">
		<!-- Logo + Top Nav -->
		<?php include "header-top.php";?>
		<!-- End Logo + Top Nav -->
		
		<!-- Main Nav -->
		<?php include "menu-tab.php";?>
		<!-- End Main Nav -->
	</div>
</div>
<!-- End Header -->

<!-- Container -->
<div id="container"  style=" height:auto;">
	<div class="shell">
		
		<!-- Small Nav -->
		<div class="small-nav">
			<a href="#">Sign Faces</a>
			</div>
		<!-- End Small Nav -->
		
		<!-- Message OK -->
		<!-- End Message OK -->
        <!-- Message Error -->
        <!-- End Message Error -->
        <br />
		<!-- Main -->
		<div id="main"  style=" height:auto;">
	<?php if($_REQUEST['action'] == "add" || $_REQUEST['action'] == "edit") {
?>
		<table width="100%" border="0" cellspacing="0" cellpadding="0">
			  <tr>
				<td width="69%" height="30"><?php
				if(isset($_REQUEST['msg'])) {
					if($_REQUEST['msg'] == '3') {
						echo "DATA SAVED";
					}
				}
				?></td>
				<td width="31%" height="30" align="left" valign="top"><a href="signFaceList.php">List Sign Faces</a>&nbsp;&nbsp;&nbsp;&nbsp;</td>
			  </tr>
		  </table>
		  <?php }
		  if($_REQUEST['action'] == "view") {
		  ?>
		  <table width="100%" border="0" cellspacing="0" cellpadding="0">
			  <tr>
				<td width="60%" height="30">&nbsp;</td>
				<td width="40%" height="30" align="left" valign="top"> <a href="signFaceManager.php?action=add" class="pageLink"><b>Create New</b></a>|<a href="signFaceList.php" class="menuLink"><b>List Sign Faces</b></a></td>
			  </tr>
		  </table>
		
		  <?php }?>
			<div class="cl">&nbsp;</div>
			
			<!-- Content -->
			<div id="content" style="width:940px;">
				
				<!-- Box -->
				<!-- End Box -->
                <!-- Box -->
<div class="box">
					<!-- Box Head -->
					<div class="box-head">
						<h2>
						<?php
						if($_REQUEST['action'] == 'edit') {
						echo '<strong>Edit Sign Faces</strong>';
						}
						
						if($_REQUEST['action'] == 'add') {
						echo '<strong>ADD SIGN FACE TO GALLERY</strong>';
						}
						if($_REQUEST['action'] == 'view') {
						echo '<strong>View Sign Faces</strong>';
						}
						?>	
						</h2>
					</div>
					<!-- End Box Head -->
					
					
						
		  <div>
				<?php if($_REQUEST['action'] == "add" || $_REQUEST['action'] == "edit") {
?>
				<!------------------------------------------------------------>
			<form method="post" name="signFacesForm" id="signFacesForm" action="signFaceManagerAction.php" enctype="multipart/form-data">
			  <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center" style="border:1px #FF0000 solid;">
                <tr>
                  <td height="10" colspan="6" style=" font-size:11px;">&nbsp;</td>
                </tr>
                <tr>
                  <td width="0%" height="15" style=" font-size:11px;">&nbsp;</td>
                  <td width="14%" height="15" style=" font-size:11px;">&nbsp;</td>
                  <td height="15" colspan="4" align="right" style="font-size:12px;">&nbsp;</td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Sign Face ID </td>
                   <td width="30%" height="30" style=" font-size:12px; font-weight:bold;"><?php 
					  if($_REQUEST['action'] == 'edit') {
					  	echo @$sf_id;
					  } 
					  if($_REQUEST['action'] == 'add') {
					  	echo $idQry['sf_id']+1;
					  }
					  ?></td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td><?php 
				  if($_REQUEST['action'] == 'edit') {
					  ?>
					  <a href="galleryList.php">Fill Form Gallery</a>
					  <?
					  } 
				  ?></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;"><!--Catalog-->
                  Post Id</td>
                  <td width="30%" height="30">
				  <?php 
					  if($_REQUEST['action'] == 'edit') {
					  	?>
						<b><?php echo @$editQry['sf_post_id']?></b>
						 <input type="hidden" name="sf_post_id" id="sf_post_id" size="30" value="<?php echo @$editQry['sf_post_id']?>"/>
						<?php
					  } 
					  if($_REQUEST['action'] == 'add') {
						?>
						<b><?php echo @$_REQUEST['sp_id']?></b>
						<input type="hidden" name="sf_post_id" id="sf_post_id" size="30" value="<?php echo @$_REQUEST['sp_id']?>"/>
						<?php
					  }
					  ?>
				  <input type="hidden" name="sf_catalog_item_yesno" value="1" /><?php /*?><select name="sf_catalog_item_yesno" style="width:200px;">
                      <option value="1" <?php if($editQry['sf_catalog_item_yesno'] == "1") { ?> selected="selected"<?php } ?>>Yes</option>
                      <option value="2" <?php if($editQry['sf_catalog_item_yesno'] == "2") { ?> selected="selected"<?php } ?>>No</option>
                      <option value="3" <?php if($editQry['sf_catalog_item_yesno'] == "3") { ?> selected="selected"<?php } ?>>Unset</option>
                    </select> <?php */?>                 </td>
                  <td width="1%">&nbsp;</td>
                  <td width="17%"><span style=" font-size:12px; padding-left:10px;">Status</span></td>
                  <td width="38%"><select name="sf_status" style="width:200px;">
                    <?php foreach ($arrStatus as $keyStatus => $statusValue) { 
						if($editQry['sf_status'] == $keyStatus) {
						$selectStatus = 'selected';
						} else {
						$selectStatus = '';
						}
					?>
                    <option value="<?php echo $keyStatus; ?>" <?php echo $selectStatus;?>><?php echo $statusValue; ?></option>
                    <?php } ?>
                  </select></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px; color:#FF0000;">Installed</td>
                  <td height="30">
				  <input type="text" name="sf_date_installed" id="sf_date_installed" size="30" value="<?php if(isset($editQry['sf_date_installed'])) { if($editQry['sf_date_installed'] != "0000-00-00") { if(date('m-d-Y',strtotime($editQry['sf_date_installed'])) != "12-31-1969") { echo date('m-d-Y',strtotime($editQry['sf_date_installed'])); } } }?>" readonly="" disabled="disabled"/></td>
                  <td>&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px; color:#FF0000;">Inspected</td>
                  <td><input type="text" name="sf_date_last_insp" id="sf_date_last_insp" size="30" value="<?php 
				  if($editQry['sf_date_last_insp'] != "0000-00-00") { if(date('m-d-Y',strtotime($editQry['sf_date_last_insp'])) != "12-31-1969") { echo date('m-d-Y',strtotime($editQry['sf_date_last_insp'])); } }?>" readonly="" disabled="disabled"/></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Action Needed</td>
                  <td height="30"><select name="sf_action_needed" style="width:200px;">
                     <?php foreach ($arrAN as $keyAN => $ANValue) { 
						if($editQry['sf_action_needed'] == $keyAN) {
						$selectAN = 'selected';
						} else {
						$selectAN = '';
						}
					?>
				<option value="<?php echo $keyAN; ?>" <?php echo $selectAN;?>><?php echo $ANValue; ?></option>
				<?php } ?>
					 
                  </select></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px; color:#FF0000;">Next Inspection</span></td>
                  <td><input type="text" name="sf_date_next_insp" id="sf_date_next_insp" size="30" value="<?php 
				  if($editQry['sf_date_next_insp'] != "0000-00-00") { if(date('m-d-Y',strtotime($editQry['sf_date_next_insp'])) != "12-31-1969") { echo date('m-d-Y',strtotime($editQry['sf_date_next_insp'])); } }?>" readonly="" disabled="disabled"/></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Agency</td>
                  <td height="30"><select name="sf_agency" style="width:200px;">
                    <?php foreach ($arrAgency as $keyAgency => $agencyValue) { 
						if($editQry['sf_agency'] == $keyAgency) {
						$selectAgency = 'selected';
						} else {
						$selectAgency = '';
						}
					?>
                    <option value="<?php echo $keyAgency; ?>" <?php echo $selectAgency;?>><?php echo $agencyValue; ?></option>
                    <?php } ?>
                  </select></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px; color:#FF0000;">Replace</span></td>
                  <td><input type="text" name="sf_replace_date" id="sf_replace_date" size="30" value="<?php 
				  if($editQry['sf_replace_date'] != "0000-00-00") {  if(date('m-d-Y',strtotime($editQry['sf_replace_date'])) != "12-31-1969") { echo date('m-d-Y',strtotime($editQry['sf_replace_date'])); } } ?>" readonly="" disabled="disabled"/></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">&nbsp;</td>
                  <td height="30">&nbsp;</td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px;">District</span></td>
                  <td><select name="sf_district" style="width:200px;">
				  <?php foreach ($arrDistrict as $keyDistrict => $DistrictValue) { 
						if($editQry['sf_district'] == $keyDistrict) {
						$selectDistrict = 'selected';
						} else {
						$selectDistrict = '';
						}
					?>
				<option value="<?php echo $keyDistrict; ?>" <?php echo $selectAgency;?>><?php echo $DistrictValue; ?></option>
				<?php } ?>
                     
                  </select></td>
                </tr>
                <tr align="left" style="background-color:#FF0000; color:#FFFFFF;">
                  <td height="30" bgcolor="#FF0000" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" bgcolor="#FF0000" style=" font-size:12px;"><strong>MUTCD</strong></td>
                  <td height="30" bgcolor="#FF0000">&nbsp;</td>
                  <td bgcolor="#FF0000">&nbsp;</td>
                  <td bgcolor="#FF0000">&nbsp;</td>
                  <td bgcolor="#FF0000">&nbsp;</td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px;">&nbsp;</td>
                  <td height="30">&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
				<?php if($_REQUEST['action'] == 'edit') {?>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">&nbsp;</td>
                  <td height="30"><img src="photo/<?php echo @$editQry['sf_thumbnail']?>" width="100" height="100" /></td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
				<?php } ?>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Sign Code </td>
                  <td height="30">
				  <input type="text" name="sf_sign_code" id="sf_sign_code" size="30" value="<?php echo @$editQry['sf_sign_code']?>"/>
				 <?php /*?> <select name="sf_sign_code" style="width:200px;">
				  <?php foreach ($arrSC as $keySC => $SCValue) { 
						if($editQry['sf_sign_code'] == $keySC) {
						$selectSC = 'selected';
						} else {
						$selectSC = '';
						}
					?>
				<option value="<?php echo $keySC; ?>" <?php echo $selectSC;?>><?php echo $SCValue; ?></option>
				<?php } ?>
                   
                  </select><?php */?></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px;">Size</span></td>
                  <td><input type="text" name="sf_size" id="sf_size" size="30" value="<?php echo @$editQry['sf_size']?>"/></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Classification</td>
                  <td height="30"><select name="sf_classification" style="width:200px;">
				  <?php foreach ($arrClass as $keyClass => $ClassValue) { 
						if($editQry['sf_classification'] == $keyClass) {
						$selectClass = 'selected';
						} else {
						$selectClass = '';
						}
					?>
				<option value="<?php echo $keyClass; ?>" <?php echo $selectClass;?>><?php echo $ClassValue; ?></option>
				<?php } ?>
                   
                     
                  </select></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px;">Width </span></td>
                  <td><input type="text" name="sf_width" id="sf_width" size="30" value="<?php echo @$editQry['sf_width']?>"/></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;"><!--Client-->Cost</td>
                  <td height="30">
				  <input type="text" name="sf_cost" id="sf_cost" size="10" value="<?php echo @$editQry['sf_cost'];?>"/>USD
				  <?php /*?><input type="text" name="sf_master_client" id="sf_master_client" size="30" value="<?php echo @$editQry['sf_master_client']?>"/><?php */?></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px;">Height</span></td>
                  <td><input type="text" name="sf_height" id="sf_height" size="30" value="<?php echo @$editQry['sf_height']?>"/></td>
                </tr>
                <tr align="left" style="background-color:#FF0000; color:#FFFFFF;">
                  <td height="30" bgcolor="#FF0000" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" bgcolor="#FF0000" style=" font-size:12px;"><strong>Details</strong></td>
                  <td height="30" bgcolor="#FF0000">&nbsp;</td>
                  <td bgcolor="#FF0000">&nbsp;</td>
                  <td bgcolor="#FF0000">&nbsp;</td>
                  <td bgcolor="#FF0000">&nbsp;</td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px;">&nbsp;</td>
                  <td height="30">&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">legend</td>
                  <td height="30"><input type="text" name="sf_legend" id="sf_legend" size="30" value="<?php echo @$editQry['sf_legend']?>" /></td>
                  <td>&nbsp;</td>
                  <td><span style="font-size:12px; padding-left:10px;">Min Reflection</span></td>
                  <td><input type="text" name="sf_min_refl" id="sf_min_refl" size="30" value="<?php echo @$editQry['sf_min_refl']?>"/></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Bg Color</td>
                  <td height="30"><select name="sf_bgcolor" style="width:200px;">
				   <?php foreach ($arrBGC as $keyBGC => $BGCValue) { 
						if($editQry['sf_bgcolor'] == $keyBGC) {
						$selectBGC = 'selected';
						} else {
						$selectBGC = '';
						}
					?>
				<option value="<?php echo $keyBGC; ?>" <?php echo $selectBGC;?>><?php echo $BGCValue; ?></option>
				<?php } ?>
                   
                     
                      
                  </select></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px; color:#FF0000;">Bg Value </span></td>
                  <td><input type="text" name="sf_bgvalue" id="sf_bgvalue" size="30" value="<?php echo @$editQry['sf_bgvalue']?>" disabled="disabled"/></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Leg Color </td>
                  <td height="30"><select name="sf_legcolor" style="width:200px;">
				  <?php foreach ($arrLC as $keyLC => $LCValue) { 
						if($editQry['sf_legcolor'] == $keyLC) {
						$selectLC = 'selected';
						} else {
						$selectLC = '';
						}
					?>
				<option value="<?php echo $keyLC; ?>" <?php echo $selectLC;?>><?php echo $keyLC; ?></option>
				<?php } ?>
                      
                  </select></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px; color:#FF0000;">Leg Value </span></td>
                  <td><input type="text" name="sf_legvalue" id="sf_legvalue" size="30" value="<?php echo @$editQry['sf_legvalue']?>" disabled="disabled"/></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Other Color</td>
                  <td height="30"><select name="sf_othercolor" style="width:200px;">
				   <?php foreach ($arrOC as $keyOC => $OCValue) { 
						if($editQry['sf_othercolor'] == $keyOC) {
						$selectOC = 'selected';
						} else {
						$selectOC = '';
						}
					?>
				<option value="<?php echo $keyOC; ?>" <?php echo $selectOC;?>><?php echo $OCValue; ?></option>
				<?php } ?>
                     
                  </select></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px; color:#FF0000;">Other Value </span></td>
                  <td><input type="text" name="sf_othervalue" id="sf_othervalue" size="30" value="<?php echo @$editQry['sf_othervalue']?>" disabled="disabled"/></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Shape</td>
                  <td height="30"><select name="sf_shape" style="width:200px;">
				   <?php foreach ($arrShape as $keyShape => $ShapeValue) { 
						if($editQry['sf_shape'] == $keyShape) {
						$selectShape = 'selected';
						} else {
						$selectShape = '';
						}
					?>
				<option value="<?php echo $keyShape; ?>" <?php echo $selectShape;?>><?php echo $ShapeValue; ?></option>
				<?php } ?>
                      
                  </select></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px; color:#FF0000;">Direction 1</span></td>
                  <td><select name="sf_direction1" style="width:200px;" disabled="disabled">
				   <?php foreach ($arrD1 as $keyD1 => $D1Value) { 
						if($editQry['sf_direction1'] == $keyD1) {
						$selectD1 = 'selected';
						} else {
						$selectD1 = '';
						}
					?>
				<option value="<?php echo $keyD1; ?>" <?php echo $selectD1;?>><?php echo $D1Value; ?></option>
				<?php } ?>
                      
                  </select></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Backing</td>
                  <td height="30"><select name="sf_backing" style="width:200px;">
				  <?php foreach ($arrBacking as $keyBacking => $BackingValue) { 
						if($editQry['sf_backing'] == $keyBacking) {
						$selectBacking = 'selected';
						} else {
						$selectBacking = '';
						}
					?>
				<option value="<?php echo $keyBacking; ?>" <?php echo $selectBacking;?>><?php echo $BackingValue; ?></option>
				<?php } ?>
                     
                     
                  </select></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px; color:#FF0000;">Direction 2</span></td>
                  <td><select name="sf_direction2" style="width:200px;" disabled="disabled">
				    <?php foreach ($arrD2 as $keyD2 => $D2Value) { 
						if($editQry['sf_direction2'] == $keyD2) {
						$selectD2 = 'selected';
						} else {
						$selectD2 = '';
						}
					?>
				<option value="<?php echo $keyD2; ?>" <?php echo $selectD2;?>><?php echo $D2Value; ?></option>
				<?php } ?>
                     
                  </select></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Manufacturer</td>
                  <td height="30"><select name="sf_manufacturer" style="width:200px;">
				   <?php foreach ($arrManu as $keyManu => $ManuValue) { 
						if($editQry['sf_manufacturer'] == $keyManu) {
						$selectManu = 'selected';
						} else {
						$selectManu = '';
						}
					?>
				<option value="<?php echo $keyManu; ?>" <?php echo $selectManu;?>><?php echo $ManuValue; ?></option>
				<?php } ?>
                      
                  </select></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px;">Sheeting</span></td>
                  <td><select name="sf_sheeting" style="width:200px;">
				   <?php foreach ($arrSheet as $keySheet => $SheetValue) { 
						if($editQry['sf_sheeting'] == $keySheet) {
						$selectSheet = 'selected';
						} else {
						$selectSheet = '';
						}
					?>
				<option value="<?php echo $keySheet; ?>" <?php echo $selectSheet;?>><?php echo $SheetValue; ?></option>
				<?php } ?>
                      
                  </select></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Bracket Type </td>
                  <td height="30"><select name="sf_bracket_type" style="width:200px;">
				  <?php foreach ($arrBrack as $keyBrack => $BrackValue) { 
						if($editQry['sf_bracket_type'] == $keyBrack) {
						$selectBrack = 'selected';
						} else {
						$selectBrack = '';
						}
					?>
				<option value="<?php echo $keyBrack; ?>" <?php echo $selectBrack;?>><?php echo $BrackValue; ?></option>
				<?php } ?>
                     
                  </select></td>
                  <td>&nbsp;</td>
                  <td><span style="font-size:12px; padding-left:10px;">Sheet Manufacture </span></td>
                  <td><select name="sf_sheeting_manuf" style="width:200px;">
                    <?php foreach ($arrSheetManu as $keySheetManu => $SheetManuValue) { 
						if($editQry['sf_sheeting_manuf'] == $keySheetManu) {
						$selectSheetManu = 'selected';
						} else {
						$selectSheetManu = '';
						}
					?>
                    <option value="<?php echo $keySheetManu; ?>" <?php echo $selectSheetManu;?>><?php echo $SheetManuValue; ?></option>
                    <?php } ?>
                  </select></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Position</td>
                  <td height="30"><select name="sf_position" style="width:200px;">
				   <?php foreach ($arrPOS as $keyPOS => $POSValue) { 
						if($editQry['sf_position'] == $keyPOS) {
						$selectPOS = 'selected';
						} else {
						$selectPOS = '';
						}
					?>
				<option value="<?php echo $keyPOS; ?>" <?php echo $selectPOS;?>><?php echo $POSValue; ?></option>
				<?php } ?>
                      
                  </select></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px;">Mang Method</span></td>
                  <td><select name="sf_mang_method" style="width:200px;">
                    <?php foreach ($arrMangMET as $keyMangMET => $MangMETValue) { 
						if($editQry['sf_mang_method'] == $arrMangMET) {
						$selectMangMET = 'selected';
						} else {
						$selectMangMET = '';
						}
					?>
                    <option value="<?php echo $arrMangMET; ?>" <?php echo $selectMangMET;?>><?php echo $MangMETValue; ?></option>
                    <?php } ?>
                  </select></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px;"><span style=" font-size:12px; padding-left:10px;">Mount Height</span></td>
                  <td height="30"><input type="text" name="sf_mount_height" id="sf_mount_height" size="30" value="<?php echo @$editQry['sf_mount_height']?>"/></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px;">Assess Method</span></td>
                  <td><select name="sf_assess_method" style="width:200px;">
                    <?php foreach ($arrACCMET as $keyACCMET => $ACCMETValue) { 
						if($editQry['sf_assess_method'] == $keyACCMET) {
						$selectACCMET = 'selected';
						} else {
						$selectACCMET = '';
						}
					?>
                    <option value="<?php echo $keyACCMET; ?>" <?php echo $selectACCMET;?>><?php echo $ACCMETValue; ?></option>
                    <?php } ?>
                  </select></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px;">&nbsp;</td>
                  <td height="30">&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr align="left" style="background-color:#FF0000; color:#FFFFFF;">
                  <td height="30" bgcolor="#FF0000" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" bgcolor="#FF0000" style=" font-size:12px;"><strong>Custom</strong></td>
                  <td height="30" bgcolor="#FF0000">&nbsp;</td>
                  <td bgcolor="#FF0000">&nbsp;</td>
                  <td bgcolor="#FF0000">&nbsp;</td>
                  <td bgcolor="#FF0000">&nbsp;</td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px;">&nbsp;</td>
                  <td height="30">&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Custom1</td>
                  <td height="30"><input type="text" name="sf_custom1" id="sf_custom1" size="30" value="<?php echo @$editQry['sf_custom1']?>"/></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px;">Yes/No1</span></td>
                  <td><select name="sf_yes_no1" style="width:200px;">
                    <option value="1" <?php if($editQry['sf_yes_no1'] == "1") { ?> selected="selected"<?php } ?>>Yes</option>
                    <option value="2" <?php if($editQry['sf_yes_no1'] == "2") { ?> selected="selected"<?php } ?>>No</option>
                    <option value="3" <?php if($editQry['sf_yes_no1'] == "3") { ?> selected="selected"<?php } ?>>Unset</option>
                  </select></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Custom2</td>
                  <td height="30"><input type="text" name="sf_custom2" id="sf_custom2" size="30" value="<?php echo @$editQry['sf_custom2']?>"/></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px;">Yes/No2</span></td>
                  <td><select name="sf_yes_no2" style="width:200px;">
                    <option value="1" <?php if($editQry['sf_yes_no2'] == "1") { ?> selected="selected"<?php } ?>>Yes</option>
                    <option value="2" <?php if($editQry['sf_yes_no2'] == "2") { ?> selected="selected"<?php } ?>>No</option>
                    <option value="3" <?php if($editQry['sf_yes_no2'] == "3") { ?> selected="selected"<?php } ?>>Unset</option>
                  </select></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Custom3</td>
                  <td height="30"><input type="text" name="sf_custom3" id="sf_custom3" size="30" value="<?php echo @$editQry['sf_custom3']?>"/></td>
                  <td>&nbsp;</td>
                  <td><span style=" font-size:12px; padding-left:10px;">Yes/No3</span></td>
                  <td><select name="sf_yes_no3" style="width:200px;">
                    <option value="1" <?php if($editQry['sf_yes_no3'] == "1") { ?> selected="selected"<?php } ?>>Yes</option>
                    <option value="2" <?php if($editQry['sf_yes_no3'] == "2") { ?> selected="selected"<?php } ?>>No</option>
                    <option value="3" <?php if($editQry['sf_yes_no3'] == "3") { ?> selected="selected"<?php } ?>>Unset</option>
                  </select></td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">&nbsp;</td>
                  <td height="30">&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr align="left" style="background-color:#FF0000; color:#FFFFFF;">
                  <td height="30" bgcolor="#FF0000" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" bgcolor="#FF0000" style=" font-size:12px;">&nbsp;</td>
                  <td height="30" bgcolor="#FF0000">&nbsp;</td>
                  <td bgcolor="#FF0000">&nbsp;</td>
                  <td bgcolor="#FF0000">&nbsp;</td>
                  <td bgcolor="#FF0000">&nbsp;</td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px;">&nbsp;</td>
                  <td height="30">&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Comments</td>
                  <td height="30"><textarea name="sf_comments" cols="35" rows="5"><?php echo @$editQry['sf_comments']?></textarea></td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
				<?php if($_REQUEST['action'] == 'edit') {?>
                    <tr align="left">
                      <td height="30" style=" font-size:11px;">&nbsp;</td>
                      <td height="30" style=" font-size:12px;">&nbsp;</td>
                      <td height="30"><img src="photo/<?php echo @$editQry['sf_photo']?>" width="100" height="100" /></td>
                      <td>&nbsp;</td>
                      <td>&nbsp;</td>
                      <td>&nbsp;</td>
                    </tr>
					<?php } ?>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Photo</td>
                  <td height="30"><input type="file" name="sf_photo" id="sf_photo" size="25" /></td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">Thumbnail</td>
                  <td height="30"><input type="file" name="sf_thumbnail" id="sf_thumbnail" size="25" /></td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr align="left">
                  <td height="30" style=" font-size:11px;">&nbsp;</td>
                  <td height="30" style=" font-size:12px; padding-left:10px;">History</td>
                  <td height="30"><textarea name="sa_activity" cols="35" rows="5"><?php echo @$editActivityQry['sa_activity']?></textarea>                  </td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                  <td height="30" colspan="2">&nbsp;</td>
                  <td height="30" colspan="4">&nbsp;</td>
                </tr>
                <tr align="left">
                  <td height="30" colspan="2">&nbsp;</td>
                  <td height="30" colspan="4"><?php if($_REQUEST['action'] == 'add') {
	?>
                      <input type="submit" name="Add" value="Add" class="button" onclick="return validationBuyerAdd()"/>
                      <input type="reset" name="reset" value="Reset" class="button" onclick="resetEditor()"/>
                      <?php
		}
		if($_REQUEST['action'] == 'edit') {
		?>
                      <input type="hidden" name="sf_id" id="sf_id" value="<?php echo $sf_id;?>" />
                      <input type="submit" name="Edit" value="Update" class="button" onclick="return validationBuyerEdit()"/>
                      <?php 
		}
		?>                  </td>
                </tr>
                <tr>
                  <td height="30" colspan="2">&nbsp;</td>
                  <td height="30" colspan="4">&nbsp;</td>
                </tr>
              </table>
			</form>
				<!------------------------------------------------------------->
		
		<?php
}
if($_REQUEST['action'] == "view") {
?>
		<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
          <tr>
            <td height="10" colspan="4" style=" font-size:11px;">&nbsp;</td>
          </tr>
          <tr>
            <td width="1%" height="15" style=" font-size:11px;">&nbsp;</td>
            <td width="19%" height="15" style=" font-size:11px;">&nbsp;</td>
            <td height="15" colspan="2" align="right" style="font-size:12px;">&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Catalog</td>
            <td width="51%" height="30">
			<?php echo @$editQry['sf_catalog_item_yesno']?>
			
            </td>
            <td width="29%">&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Post Id </td>
            <td height="30"><?php echo @$editQry['sf_post_id']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Sign Code </td>
            <td height="30">
			<?php echo @$editQry['sf_sign_code']?>
			</td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Classification</td>
            <td height="30">
			<?php echo @$editQry['sf_classification']?>
			</td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Client</td>
            <td height="30"><?php echo @$editQry['sf_master_client']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Agency</td>
            <td height="30">
			<?php echo @$editQry['sf_agency']?>
			</td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>District</td>
            <td height="30"><?php echo @$editQry['sf_district']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Installed</td>
            <td height="30"><?php echo @$editQry['sf_date_installed']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Inspected</td>
            <td height="30"><?php echo @$editQry['sf_date_last_insp']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Next Inspection</td>
            <td height="30"><?php echo @$editQry['sf_date_next_insp']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Replace</td>
            <td height="30"><?php echo @$editQry['sf_replace_date']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Status</td>
            <td height="30">
			<?php echo @$editQry['sf_status']?>
			</td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>legend</td>
            <td height="30"><?php echo @$editQry['sf_legend']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Size</td>
            <td height="30"><?php echo @$editQry['sf_size']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Width </td>
            <td height="30"><?php echo @$editQry['sf_width']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Height</td>
            <td height="30"><?php echo @$editQry['sf_height']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Direcction 1 </td>
            <td height="30">
			<?php echo @$editQry['sf_direction1']?>
			</td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Direcction 2 </td>
            <td height="30"><?php echo @$editQry['sf_direction2']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Shape</td>
            <td height="30"><?php echo @$editQry['sf_shape']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Backing</td>
            <td height="30"><?php echo @$editQry['sf_backing']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Manufacturer</td>
            <td height="30"><?php echo @$editQry['sf_manufacturer']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Sheeting</td>
            <td height="30"><?php echo @$editQry['sf_sheeting']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Bg Color </td>
            <td height="30"><?php echo @$editQry['sf_bgcolor']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Leg Color </td>
            <td height="30"><?php echo @$editQry['sf_legcolor']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Other Color </td>
            <td height="30"><?php echo @$editQry['sf_othercolor']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Bg Value </td>
            <td height="30"><?php echo @$editQry['sf_bgvalue']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Leg Value </td>
            <td height="30"><?php echo @$editQry['sf_legvalue']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Other Value </td>
            <td height="30"><?php echo @$editQry['sf_othervalue']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Mount Height </td>
            <td height="30"><?php echo @$editQry['sf_mount_height']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Bracket Type </td>
            <td height="30"><?php echo @$editQry['sf_bracket_type']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Position</td>
            <td height="30"><?php echo @$editQry['sf_position']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Custom1</td>
            <td height="30"><?php echo @$editQry['sf_custom1']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Custom2</td>
            <td height="30"><?php echo @$editQry['sf_custom2']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Custom3</td>
            <td height="30"><?php echo @$editQry['sf_custom3']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Yes/No1</td>
            <td height="30"><?php echo @$editQry['sf_yesno1']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Yes/No2</td>
            <td height="30"><?php echo @$editQry['sf_yesno2']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Yes/No3</td>
            <td height="30"><?php echo @$editQry['sf_yesno3']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Mang Method </td>
            <td height="30"><?php echo @$editQry['sf_mang_method']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Assess Method </td>
            <td height="30"><?php echo @$editQry['sf_assess_method']?></td>
            <td>&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" style=" font-size:11px;">&nbsp;</td>
            <td height="30" style=" font-size:12px;"><em></em>Comments</td>
            <td height="30"><?php echo @$editQry['sf_comments']?>
            </td>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td height="30" colspan="2">&nbsp;</td>
            <td height="30" colspan="2">&nbsp;</td>
          </tr>
          <tr align="left">
            <td height="30" colspan="2">&nbsp;</td>
            <td height="30" colspan="2">
                <input type="submit" name="edit" value="Edit" class="button" onclick="window.location.href='signFaceManager.php?action=edit&id=<?php echo $sf_id;?>'"/>
<input type="button" name="back" value="Back" class="button" onclick="window.location.href='signFaceList.php'"/>
            </td>
          </tr>
          <tr>
            <td height="30" colspan="2">&nbsp;</td>
            <td height="30" colspan="2">&nbsp;</td>
          </tr>
        </table>
		<?php
}
?>
                </div>
</div>
				<!-- End Box -->

		  </div>
			<!-- End Content -->
			
			<!-- Sidebar -->
			<!-- End Sidebar -->
<div class="cl">&nbsp;</div>			
		</div>
		<!-- Main -->
	</div>
</div>
<!-- End Container -->

<!-- Footer -->
<?php include 'footer.php';?>
<!-- End Footer -->
	
</body>
</html>